Environments (Available only for Oracle)

ORACLE_HOME
Location of ORACLE_HOME for full client only. Instant client should leave it blank.

DYLD_LIBRARY_PATH
Location of the path which contains Oracle libraries for instant client and SQL*Plus (e.g. ORACLE_HOME/lib). Always required.

User bundled instant client
Checks this option to use the Oracle Instant Client included in Navicat installation folder.

Oracle Instant Client is the simplest way to deploy a full Oracle Client application built with OCI, OCCI, JDBC-OCI, or ODBC drivers. It provides the necessary Oracle Client libraries in a small set of files. It provides the necessary Oracle Client libraries in a small set of files. It has already included in Navicat installation folder. You can also download Oracle Client / Oracle Instant Client through -

Downloading

Oracle Client
http://www.oracle.com/technology/software/products/database/index.html

Oracle Instant Client
http://www.oracle.com/technology/software/tech/oci/instantclient/index.html

Hint: MAC OS X any versions running on PPC cpu should use PPC Navicat and PPC Instant Client.
  MAC OS X 10.4 or below running on INTEL cpu should use PPC Navicat and PPC Instant Client.
  MAC OS X 10.5 or above running on INTEL cpu should use X86 Navicat and x86 Instant Client.

Installation Guide

Oracle Client for Mac OS X on Intel x86
http://download.oracle.com/docs/cd/B19306_01/install.102/e12121/toc.htm

Oracle Instant Client

  1. Download the appropriate Instant Client packages for your platform. All installations REQUIRE the Basic or Basic Lite package.
  2. Just simply unzip the packages and copy all files under /usr/lib or ~/lib (not /usr/lib/instantclient/). (Copy all files under /usr/lib for Mac OS X 10.3, otherwise, copy all files under /usr/lib or ~/lib for Mac OS X 10.4 or above.)

TNS_ADMIN
Location of the tnsnames.ora file (e.g. ORACLE_HOME/network). It is optional. Required when using TNS connection.

Notes: To change the path settings, you need to click the lock and enter your OS username and password to unlock the control.